import numpy as np
import pandas as pd
import matplotlib.pyplot as plt

df = pd.DataFrame(pd.read_csv('listings_summary_dec18.csv'))

"""
print('-----------------name-----------------')
print(df['name'].value_counts())
print('-----------------host_name-----------------')
print(df['host_name'].value_counts())
print('-----------------neighbourhood-----------------')
print(df['neighbourhood'].value_counts())
print('-----------------room_type-----------------')
print(df['room_type'].value_counts())
print('-----------------price-----------------')
print(df['price'].value_counts())
print('-----------------minimum_nights-----------------')
print(df['minimum_nights'].value_counts())


print('-----------------Missing-----------------')
print(df.isna().sum())
print('-----------------Quartile-----------------')
print(df['price'].quantile([.0, .25, 0.5, .75, 1]))


print('-----------------Histogram-----------------')
df['room_type'].hist()
plt.show()



print('-----------------Boxplot-----------------')

df.boxplot('price')
plt.show()
"""

print(df.info())
df1 = df.dropna(subset=['name','host_name'])
print(df1.info())
df2 = df1.fillna('unknow')
print(df2.info())


